Example: Find purchases by amount and date
This query extracts customers who have purchased more than $100 within a specific date range.
- Browse to IQA.
- Select Query from the drop-down list and select New.
- Select sources:
- Browse to the Common folder containing business objects.
- Select the Contact and CsActivity business objects.
- Make sure the default join in the Relations area is Contact.Id Equals CsActivity.Id.
- Define the filtering rules:
- Select the Filters tab.
- Filter on CsActivity.ActivityType.
- Mode: Basic
- Property: CsActivity.ActivityType
- Comparison: Equals
- Value: ORDER
- Add the filter.
- Filter on CsActivity.TransactionDate.
- Property: CsActivity.TransactionDate
- Comparison: Between
- Value: "1/1/1995","12/31/1995"
- Add the filter.
- Filter on CsActivity.Amount.
- Property: CsActivity.Amount
- Comparison: Greater
- Value: 100
- Add the filter.
- Define the columns to display in the output:
- Select the Display tab.
- Select the following columns:
- Using the Order drop-down list, assign:
- Contact.Id Order 1
- CsActivity.Amount Order 2
- Specify the sorting priority:
- Select the Sorting tab.
- Sort the results by Contact.Id.
- Add the selection.
- Save your settings.
- Run the query.